---------------------------------------------------------------------------------------------------
IF (SELECT OBJECT_ID('[GrantManagement].[GetAllGrantTypes]')) IS NOT NULL
BEGIN
	DROP PROCEDURE [GrantManagement].[GetAllGrantTypes] 
END
---------------------------------------------------------------------------------------------------

GO
CREATE PROCEDURE [GrantManagement].[GetAllGrantTypes]

AS 

SET NOCOUNT ON 

SELECT 
	*
	FROM 
		dbo.TypesOfGrant
	WHERE Active = 1        
	ORDER BY DisplayOrder

GO

---------------------------------------------------------------------------------------------------
-- Assign appropriate permissions
---------------------------------------------------------------------------------------------------
GRANT EXECUTE ON [GrantManagement].[GetAllGrantTypes] TO [Liberty_Users]
GO

  